House Price Profiling Report

Dataset statistics

Number of variables	21
Number of observations	21436
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.1 MiB
Average record size in memory	200.7 B

Variable types

Numeric	17
DateTime	1
Categorical	3

Alerts

`bathrooms` is highly overall correlated with `price` and 7 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`floors` is highly overall correlated with `yr_built`	High correlation
`grade` is highly overall correlated with `price` and 4 other fields	High correlation
`long` is highly overall correlated with `yr_built` and 1 other fields	High correlation
`price` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_above` is highly overall correlated with `price` and 6 other fields	High correlation
`sqft_living` is highly overall correlated with `price` and 6 other fields	High correlation
`sqft_living15` is highly overall correlated with `price` and 4 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`zipcode` is highly overall correlated with `yr_built` and 2 other fields	High correlation
`condition` is highly overall correlated with `yr_built`	High correlation
`sqft_basement` is highly overall correlated with `price` and 3 other fields	High correlation
`lat` is highly overall correlated with `zipcode`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.2%)	Imbalance
`id` has unique values	Unique
`sqft_basement` has 13015 (60.7%) zeros	Zeros
`yr_renovated` has 20526 (95.8%) zeros	Zeros

Reproduction

Analysis started	2024-11-26 14:08:51.757593
Analysis finished	2024-11-26 14:09:26.802360
Duration	35.04 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

id
Real number (ℝ)

UNIQUE

Distinct	21436
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5807653 × 10⁹

Minimum	1000102
Maximum	9.9000002 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	1000102
5-th percentile	5.1000319 × 10⁸
Q1	2.1237001 × 10⁹
median	3.9049212 × 10⁹
Q3	7.3086751 × 10⁹
95-th percentile	9.2973006 × 10⁹
Maximum	9.9000002 × 10⁹
Range	9.8990001 × 10⁹
Interquartile range (IQR)	5.184975 × 10⁹

Descriptive statistics

Standard deviation	2.8765896 × 10⁹
Coefficient of variation (CV)	0.6279714
Kurtosis	-1.2605654
Mean	4.5807653 × 10⁹
Median Absolute Deviation (MAD)	2.4027999 × 10⁹
Skewness	0.24323134
Sum	9.8193286 × 10¹³
Variance	8.2747679 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7129300520	1	< 0.1%
8929000230	1	< 0.1%
9543000205	1	< 0.1%
8137500730	1	< 0.1%
104500730	1	< 0.1%
7575610760	1	< 0.1%
629800540	1	< 0.1%
7215730120	1	< 0.1%
2064800610	1	< 0.1%
3577300040	1	< 0.1%
Other values (21426)	21426	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000102	1	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
7200080	1	< 0.1%

Value	Count	Frequency (%)
9900000190	1	< 0.1%
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300095	1	< 0.1%
9842300036	1	< 0.1%
9839301165	1	< 0.1%
9839301060	1	< 0.1%
9839301055	1	< 0.1%
9839300875	1	< 0.1%

date
Date

Distinct	372
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	851.0 KiB

Minimum	2014-05-02 00:00:00
Maximum	2015-05-27 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

HIGH CORRELATION

Distinct	3997
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	541649.96

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	75000
5-th percentile	213500
Q1	324866
median	450000
Q3	645000
95-th percentile	1160000
Maximum	7700000
Range	7625000
Interquartile range (IQR)	320134

Descriptive statistics

Standard deviation	367314.93
Coefficient of variation (CV)	0.67814078
Kurtosis	34.725226
Mean	541649.96
Median Absolute Deviation (MAD)	150000
Skewness	4.0361072
Sum	1.1610809 × 10¹⁰
Variance	1.3492026 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
450000	172	0.8%
350000	167	0.8%
550000	157	0.7%
500000	151	0.7%
425000	149	0.7%
325000	146	0.7%
400000	144	0.7%
375000	137	0.6%
300000	131	0.6%
525000	128	0.6%
Other values (3987)	19954	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	1	< 0.1%
89000	1	< 0.1%
89950	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7062500	1	< 0.1%
6885000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110800	1	< 0.1%
4668000	1	< 0.1%
4500000	1	< 0.1%
4489000	1	< 0.1%

bedrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3715712

Minimum	0
Maximum	33
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.92920466
Coefficient of variation (CV)	0.27559989
Kurtosis	49.638224
Mean	3.3715712
Median Absolute Deviation (MAD)	1
Skewness	1.9898602
Sum	72273
Variance	0.8634213
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	9731	45.4%
4	6849	32.0%
2	2736	12.8%
5	1586	7.4%
6	265	1.2%
1	194	0.9%
7	38	0.2%
0	13	0.1%
8	13	0.1%
9	6	< 0.1%
Other values (3)	5	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	0.1%
1	194	0.9%
2	2736	12.8%
3	9731	45.4%
4	6849	32.0%
5	1586	7.4%
6	265	1.2%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	265	1.2%
5	1586	7.4%
4	6849	32.0%
3	9731	45.4%

bathrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1173493

Minimum	0
Maximum	8
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	8
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.76991279
Coefficient of variation (CV)	0.36362105
Kurtosis	1.2914875
Mean	2.1173493
Median Absolute Deviation (MAD)	0.5
Skewness	0.51018057
Sum	45387.5
Variance	0.5927657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
2.5	5355	25.0%
1	3795	17.7%
1.75	3020	14.1%
2.25	2031	9.5%
2	1913	8.9%
1.5	1430	6.7%
2.75	1182	5.5%
3	747	3.5%
3.5	729	3.4%
3.25	586	2.7%
Other values (20)	648	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
0.5	4	< 0.1%
0.75	71	0.3%
1	3795	17.7%
1.25	9	< 0.1%
1.5	1430	6.7%
1.75	3020	14.1%
2	1913	8.9%
2.25	2031	9.5%
2.5	5355	25.0%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	6	< 0.1%
5.75	4	< 0.1%
5.5	10	< 0.1%
5.25	13	0.1%

sqft_living
Real number (ℝ)

HIGH CORRELATION

Distinct	1038
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2082.7049

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1430
median	1920
Q3	2550
95-th percentile	3770
Maximum	13540
Range	13250
Interquartile range (IQR)	1120

Descriptive statistics

Standard deviation	919.14647
Coefficient of variation (CV)	0.44132342
Kurtosis	5.2490757
Mean	2082.7049
Median Absolute Deviation (MAD)	550
Skewness	1.471021
Sum	44644863
Variance	844830.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	136	0.6%
1440	133	0.6%
1400	132	0.6%
1660	128	0.6%
1800	128	0.6%
1820	127	0.6%
1560	124	0.6%
1010	124	0.6%
1480	122	0.6%
1540	122	0.6%
Other values (1028)	20160	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

HIGH CORRELATION

Distinct	9782
Distinct (%)	45.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15135.638

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	520
5-th percentile	1800
Q1	5040
median	7614
Q3	10696.25
95-th percentile	43560
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5656.25

Descriptive statistics

Standard deviation	41538.621
Coefficient of variation (CV)	2.7444248
Kurtosis	284.08354
Mean	15135.638
Median Absolute Deviation (MAD)	2615.5
Skewness	13.043673
Sum	3.2444753 × 10⁸
Variance	1.725457 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	355	1.7%
6000	286	1.3%
4000	249	1.2%
7200	218	1.0%
4800	118	0.6%
7500	118	0.6%
4500	112	0.5%
8400	109	0.5%
9600	108	0.5%
3600	102	0.5%
Other values (9772)	19661	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.496198

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.54038838
Coefficient of variation (CV)	0.36117438
Kurtosis	-0.49077396
Mean	1.496198
Median Absolute Deviation (MAD)	0.5
Skewness	0.61047946
Sum	32072.5
Variance	0.2920196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10559	49.3%
2	8209	38.3%
1.5	1888	8.8%
3	611	2.9%
2.5	161	0.8%
3.5	8	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10559	49.3%
1.5	1888	8.8%
2	8209	38.3%
2.5	161	0.8%
3	611	2.9%
3.5	8	< 0.1%

Value	Count	Frequency (%)
3.5	8	< 0.1%
3	611	2.9%
2.5	161	0.8%
2	8209	38.3%
1.5	1888	8.8%
1	10559	49.3%

waterfront
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	851.0 KiB

0	21273
1	163

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21436
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21273	99.2%
1	163	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21273	99.2%
1	163	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	21273	99.2%
1	163	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21273	99.2%
1	163	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21273	99.2%
1	163	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21273	99.2%
1	163	0.8%

view
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	851.0 KiB

0	19320
2	962
3	507
1	331
4	316

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21436
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19320	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19320	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	19320	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	19320	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	19320	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	19320	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

condition
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	851.0 KiB

3	13911
4	5645
5	1687
2	164
1	29

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21436
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	5
5th row	3

Common Values

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1687	7.9%
2	164	0.8%
1	29	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1687	7.9%
2	164	0.8%
1	29	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1687	7.9%
2	164	0.8%
1	29	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1687	7.9%
2	164	0.8%
1	29	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1687	7.9%
2	164	0.8%
1	29	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21436	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1687	7.9%
2	164	0.8%
1	29	0.1%

grade
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6617373

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1742565
Coefficient of variation (CV)	0.15326243
Kurtosis	1.1902695
Mean	7.6617373
Median Absolute Deviation (MAD)	1
Skewness	0.77035741
Sum	164237
Variance	1.3788783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	8896	41.5%
8	6044	28.2%
9	2606	12.2%
6	1995	9.3%
10	1130	5.3%
11	396	1.8%
5	234	1.1%
12	89	0.4%
4	29	0.1%
13	13	0.1%
Other values (2)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	29	0.1%
5	234	1.1%
6	1995	9.3%
7	8896	41.5%
8	6044	28.2%
9	2606	12.2%
10	1130	5.3%
11	396	1.8%

Value	Count	Frequency (%)
13	13	0.1%
12	89	0.4%
11	396	1.8%
10	1130	5.3%
9	2606	12.2%
8	6044	28.2%
7	8896	41.5%
6	1995	9.3%
5	234	1.1%
4	29	0.1%

sqft_above
Real number (ℝ)

HIGH CORRELATION

Distinct	946
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1790.9604

Minimum	290
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	290
5-th percentile	850
Q1	1200
median	1560
Q3	2220
95-th percentile	3400
Maximum	9410
Range	9120
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	829.02649
Coefficient of variation (CV)	0.46289492
Kurtosis	3.3950819
Mean	1790.9604
Median Absolute Deviation (MAD)	450
Skewness	1.4442209
Sum	38391028
Variance	687284.92
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	210	1.0%
1010	204	1.0%
1200	203	0.9%
1220	186	0.9%
1140	183	0.9%
1400	180	0.8%
1060	177	0.8%
1180	177	0.8%
1340	174	0.8%
1250	173	0.8%
Other values (936)	19569	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7850	1	< 0.1%
7680	1	< 0.1%
7420	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%

sqft_basement
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	306
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291.7445

Minimum	0
Maximum	4820
Zeros	13015
Zeros (%)	60.7%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	560
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	560

Descriptive statistics

Standard deviation	442.78198
Coefficient of variation (CV)	1.5177047
Kurtosis	2.7119878
Mean	291.7445
Median Absolute Deviation (MAD)	0
Skewness	1.5768731
Sum	6253835
Variance	196055.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13015	60.7%
600	220	1.0%
700	215	1.0%
500	211	1.0%
800	206	1.0%
400	184	0.9%
1000	147	0.7%
900	143	0.7%
300	141	0.7%
480	106	0.5%
Other values (296)	6848	31.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13015	60.7%
10	1	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2850	1	< 0.1%
2810	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%

yr_built
Real number (ℝ)

HIGH CORRELATION

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.0984

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1952
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.385277
Coefficient of variation (CV)	0.014908072
Kurtosis	-0.65434573
Mean	1971.0984
Median Absolute Deviation (MAD)	23
Skewness	-0.47457738
Sum	42252466
Variance	863.49449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	559	2.6%
2006	454	2.1%
2005	450	2.1%
2004	429	2.0%
2003	422	2.0%
2007	415	1.9%
1977	415	1.9%
1978	384	1.8%
1968	379	1.8%
2008	367	1.7%
Other values (106)	17162	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	86	0.4%
1901	29	0.1%
1902	27	0.1%
1903	45	0.2%
1904	44	0.2%
1905	74	0.3%
1906	91	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	199	0.9%
2012	169	0.8%
2011	130	0.6%
2010	143	0.7%
2009	229	1.1%
2008	367	1.7%
2007	415	1.9%
2006	454	2.1%

yr_renovated
Real number (ℝ)

ZEROS

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.7298

Minimum	0
Maximum	2015
Zeros	20526
Zeros (%)	95.8%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	402.43101
Coefficient of variation (CV)	4.7495806
Kurtosis	18.610747
Mean	84.7298
Median Absolute Deviation (MAD)	0
Skewness	4.5395471
Sum	1816268
Variance	161950.72
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20526	95.8%
2014	91	0.4%
2013	37	0.2%
2003	36	0.2%
2005	35	0.2%
2007	35	0.2%
2000	35	0.2%
2004	26	0.1%
1990	24	0.1%
2006	24	0.1%
Other values (60)	567	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20526	95.8%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%

Value	Count	Frequency (%)
2015	16	0.1%
2014	91	0.4%
2013	37	0.2%
2012	11	0.1%
2011	13	0.1%
2010	18	0.1%
2009	22	0.1%
2008	18	0.1%
2007	35	0.2%
2006	24	0.1%

zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.862

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98117
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	53.469371
Coefficient of variation (CV)	0.00054517268
Kurtosis	-0.84968929
Mean	98077.862
Median Absolute Deviation (MAD)	42
Skewness	0.4081288
Sum	2.1023971 × 10⁹
Variance	2858.9736
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	600	2.8%
98038	587	2.7%
98115	576	2.7%
98052	571	2.7%
98117	548	2.6%
98042	547	2.6%
98034	543	2.5%
98118	499	2.3%
98023	492	2.3%
98006	490	2.3%
Other values (60)	15983	74.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
98001	359	1.7%
98002	197	0.9%
98003	276	1.3%
98004	315	1.5%
98005	168	0.8%
98006	490	2.3%
98007	139	0.6%
98008	283	1.3%
98010	99	0.5%
98011	194	0.9%

Value	Count	Frequency (%)
98199	316	1.5%
98198	275	1.3%
98188	135	0.6%
98178	258	1.2%
98177	254	1.2%
98168	264	1.2%
98166	250	1.2%
98155	442	2.1%
98148	56	0.3%
98146	281	1.3%

lat
Real number (ℝ)

HIGH CORRELATION

Distinct	5034
Distinct (%)	23.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560156

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.4711
median	47.572
Q3	47.678
95-th percentile	47.749625
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.2069

Descriptive statistics

Standard deviation	0.13860131
Coefficient of variation (CV)	0.0029142317
Kurtosis	-0.67359967
Mean	47.560156
Median Absolute Deviation (MAD)	0.10475
Skewness	-0.4881646
Sum	1019499.5
Variance	0.019210324
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.5491	17	0.1%
47.6624	17	0.1%
47.6846	17	0.1%
47.5322	17	0.1%
47.6955	16	0.1%
47.6711	16	0.1%
47.6886	16	0.1%
47.6904	15	0.1%
47.6647	15	0.1%
47.686	15	0.1%
Other values (5024)	21275	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

HIGH CORRELATION

Distinct	752
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.2137

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21436
Negative (%)	100.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.23
Q3	-122.124
95-th percentile	-121.979
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.204

Descriptive statistics

Standard deviation	0.14089598
Coefficient of variation (CV)	-0.0011528657
Kurtosis	1.0455319
Mean	-122.2137
Median Absolute Deviation (MAD)	0.101
Skewness	0.88192326
Sum	-2619772.8
Variance	0.019851678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	114	0.5%
-122.3	110	0.5%
-122.362	102	0.5%
-122.291	100	0.5%
-122.363	99	0.5%
-122.372	98	0.5%
-122.357	95	0.4%
-122.288	95	0.4%
-122.365	94	0.4%
-122.346	93	0.4%
Other values (742)	20436	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

HIGH CORRELATION

Distinct	777
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1988.3144

Minimum	399
Maximum	6210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2370
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range (IQR)	880

Descriptive statistics

Standard deviation	685.69909
Coefficient of variation (CV)	0.34486452
Kurtosis	1.593321
Mean	1988.3144
Median Absolute Deviation (MAD)	410
Skewness	1.1058446
Sum	42621507
Variance	470183.25
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	193	0.9%
1440	190	0.9%
1560	190	0.9%
1500	179	0.8%
1460	168	0.8%
1800	166	0.8%
1720	165	0.8%
1580	165	0.8%
1610	164	0.8%
1620	163	0.8%
Other values (767)	19693	91.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%

sqft_lot15
Real number (ℝ)

HIGH CORRELATION

Distinct	8689
Distinct (%)	40.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12785.961

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	851.0 KiB

Quantile statistics

Minimum	651
5-th percentile	1989.5
Q1	5100
median	7620
Q3	10087.25
95-th percentile	37197
Maximum	871200
Range	870549
Interquartile range (IQR)	4987.25

Descriptive statistics

Standard deviation	27375.467
Coefficient of variation (CV)	2.1410567
Kurtosis	150.32404
Mean	12785.961
Median Absolute Deviation (MAD)	2508.5
Skewness	9.4953799
Sum	2.7407987 × 10⁸
Variance	7.4941622 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	425	2.0%
4000	355	1.7%
6000	286	1.3%
7200	210	1.0%
4800	144	0.7%
7500	142	0.7%
8400	115	0.5%
4500	110	0.5%
3600	110	0.5%
5100	109	0.5%
Other values (8679)	19430	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
386812	1	< 0.1%

Heatmap
Table

	bathrooms	bedrooms	condition	floors	grade	id	lat	long	price	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	yr_renovated	zipcode
bathrooms	1.000	0.522	0.130	0.546	0.657	0.014	0.007	0.260	0.495	0.690	0.191	0.745	0.570	0.069	0.063	0.114	0.102	0.566	0.043	-0.203
bedrooms	0.522	1.000	0.023	0.227	0.382	0.006	-0.023	0.191	0.345	0.540	0.230	0.648	0.445	0.217	0.202	0.038	0.000	0.179	0.017	-0.168
condition	0.130	0.023	1.000	-0.291	-0.171	-0.024	-0.023	-0.087	0.017	-0.161	0.162	-0.065	-0.089	0.115	0.118	0.024	0.017	-0.398	-0.067	-0.021
floors	0.546	0.227	-0.291	1.000	0.501	0.018	0.024	0.148	0.320	0.598	-0.273	0.400	0.305	-0.235	-0.232	0.023	0.022	0.552	0.012	-0.060
grade	0.657	0.382	-0.171	0.501	1.000	0.018	0.102	0.221	0.656	0.712	0.092	0.716	0.662	0.153	0.157	0.142	0.118	0.499	0.016	-0.179
id	0.014	0.006	-0.024	0.018	0.018	1.000	-0.005	0.006	0.002	0.002	0.001	0.000	-0.001	-0.117	-0.115	0.028	0.006	0.026	-0.018	-0.005
lat	0.007	-0.023	-0.023	0.024	0.102	-0.005	1.000	-0.144	0.456	-0.027	0.114	0.029	0.026	-0.121	-0.116	0.068	0.034	-0.126	0.025	0.249
long	0.260	0.191	-0.087	0.148	0.221	0.006	-0.144	1.000	0.061	0.385	-0.201	0.284	0.380	0.371	0.373	0.085	0.097	0.411	-0.076	-0.578
price	0.495	0.345	0.017	0.320	0.656	0.002	0.456	0.061	1.000	0.540	0.252	0.644	0.572	0.076	0.064	0.208	0.320	0.098	0.102	-0.006
sqft_above	0.690	0.540	-0.161	0.598	0.712	0.002	-0.027	0.385	0.540	1.000	-0.167	0.844	0.697	0.273	0.255	0.089	0.082	0.471	0.030	-0.277
sqft_basement	0.191	0.230	0.162	-0.273	0.092	0.001	0.114	-0.201	0.252	-0.167	1.000	0.327	0.129	0.037	0.031	0.159	0.135	-0.180	0.063	0.115
sqft_living	0.745	0.648	-0.065	0.400	0.716	0.000	0.029	0.284	0.644	0.844	0.327	1.000	0.747	0.306	0.285	0.148	0.140	0.351	0.052	-0.206
sqft_living15	0.570	0.445	-0.089	0.305	0.662	-0.001	0.026	0.380	0.572	0.697	0.129	0.747	1.000	0.361	0.367	0.146	0.089	0.334	-0.006	-0.287
sqft_lot	0.069	0.217	0.115	-0.235	0.153	-0.117	-0.121	0.371	0.076	0.273	0.037	0.306	0.361	1.000	0.923	0.040	0.014	-0.039	0.008	-0.320
sqft_lot15	0.063	0.202	0.118	-0.232	0.157	-0.115	-0.116	0.373	0.064	0.255	0.031	0.285	0.367	0.923	1.000	0.035	0.000	-0.018	0.009	-0.327
view	0.114	0.038	0.024	0.023	0.142	0.028	0.068	0.085	0.208	0.089	0.159	0.148	0.146	0.040	0.035	1.000	0.595	-0.068	0.096	0.080
waterfront	0.102	0.000	0.017	0.022	0.118	0.006	0.034	0.097	0.320	0.082	0.135	0.140	0.089	0.014	0.000	0.595	1.000	-0.029	0.092	0.030
yr_built	0.566	0.179	-0.398	0.552	0.499	0.026	-0.126	0.411	0.098	0.471	-0.180	0.351	0.334	-0.039	-0.018	-0.068	-0.029	1.000	-0.215	-0.315
yr_renovated	0.043	0.017	-0.067	0.012	0.016	-0.018	0.025	-0.076	0.102	0.030	0.063	0.052	-0.006	0.008	0.009	0.096	0.092	-0.215	1.000	0.062
zipcode	-0.203	-0.168	-0.021	-0.060	-0.179	-0.005	0.249	-0.578	-0.006	-0.277	0.115	-0.206	-0.287	-0.320	-0.327	0.080	0.030	-0.315	0.062	1.000

Heatmap
Table

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
id	1.000	0.006	-0.018	0.001	0.004	-0.013	-0.133	0.018	-0.003	0.011	-0.024	0.006	-0.012	-0.006	0.021	-0.017	-0.008	-0.003	0.019	-0.004	-0.140
date	0.006	1.000	-0.006	-0.018	-0.036	-0.036	0.006	-0.024	0.001	-0.002	-0.052	-0.042	-0.029	-0.019	-0.002	-0.025	0.003	-0.033	-0.008	-0.032	0.002
price	-0.018	-0.006	1.000	0.309	0.524	0.701	0.089	0.255	0.267	0.397	0.035	0.666	0.605	0.324	0.051	0.127	-0.051	0.307	0.019	0.584	0.082
bedrooms	0.001	-0.018	0.309	1.000	0.517	0.578	0.032	0.175	-0.007	0.080	0.028	0.358	0.478	0.303	0.154	0.018	-0.154	-0.010	0.130	0.393	0.029
bathrooms	0.004	-0.036	0.524	0.517	1.000	0.754	0.087	0.500	0.064	0.187	-0.128	0.665	0.685	0.284	0.505	0.051	-0.203	0.023	0.222	0.568	0.087
sqft_living	-0.013	-0.036	0.701	0.578	0.754	1.000	0.172	0.353	0.104	0.284	-0.061	0.762	0.877	0.434	0.317	0.055	-0.199	0.051	0.239	0.756	0.183
sqft_lot	-0.133	0.006	0.089	0.032	0.087	0.172	1.000	-0.006	0.022	0.075	-0.009	0.113	0.183	0.015	0.052	0.008	-0.129	-0.086	0.230	0.144	0.718
floors	0.018	-0.024	0.255	0.175	0.500	0.353	-0.006	1.000	0.023	0.028	-0.267	0.457	0.523	-0.246	0.489	0.006	-0.058	0.049	0.124	0.279	-0.012
waterfront	-0.003	0.001	0.267	-0.007	0.064	0.104	0.022	0.023	1.000	0.403	0.017	0.083	0.072	0.081	-0.027	0.093	0.031	-0.014	-0.042	0.087	0.031
view	0.011	-0.002	0.397	0.080	0.187	0.284	0.075	0.028	0.403	1.000	0.045	0.250	0.167	0.276	-0.055	0.104	0.087	0.006	-0.080	0.279	0.073
condition	-0.024	-0.052	0.035	0.028	-0.128	-0.061	-0.009	-0.267	0.017	0.045	1.000	-0.148	-0.161	0.174	-0.365	-0.061	0.005	-0.015	-0.108	-0.095	-0.004
grade	0.006	-0.042	0.666	0.358	0.665	0.762	0.113	0.457	0.083	0.250	-0.148	1.000	0.756	0.167	0.445	0.014	-0.183	0.113	0.197	0.713	0.118
sqft_above	-0.012	-0.029	0.605	0.478	0.685	0.877	0.183	0.523	0.072	0.167	-0.161	0.756	1.000	-0.052	0.423	0.023	-0.260	-0.002	0.343	0.732	0.193
sqft_basement	-0.006	-0.019	0.324	0.303	0.284	0.434	0.015	-0.246	0.081	0.276	0.174	0.167	-0.052	1.000	-0.135	0.072	0.075	0.109	-0.146	0.199	0.017
yr_built	0.021	-0.002	0.051	0.154	0.505	0.317	0.052	0.489	-0.027	-0.055	-0.365	0.445	0.423	-0.135	1.000	-0.226	-0.346	-0.149	0.409	0.325	0.070
yr_renovated	-0.017	-0.025	0.127	0.018	0.051	0.055	0.008	0.006	0.093	0.104	-0.061	0.014	0.023	0.072	-0.226	1.000	0.064	0.029	-0.069	-0.003	0.008
zipcode	-0.008	0.003	-0.051	-0.154	-0.203	-0.199	-0.129	-0.058	0.031	0.087	0.005	-0.183	-0.260	0.075	-0.346	0.064	1.000	0.267	-0.565	-0.278	-0.147
lat	-0.003	-0.033	0.307	-0.010	0.023	0.051	-0.086	0.049	-0.014	0.006	-0.015	0.113	-0.002	0.109	-0.149	0.029	0.267	1.000	-0.136	0.048	-0.087
long	0.019	-0.008	0.019	0.130	0.222	0.239	0.230	0.124	-0.042	-0.080	-0.108	0.197	0.343	-0.146	0.409	-0.069	-0.565	-0.136	1.000	0.334	0.254
sqft_living15	-0.004	-0.032	0.584	0.393	0.568	0.756	0.144	0.279	0.087	0.279	-0.095	0.713	0.732	0.199	0.325	-0.003	-0.278	0.048	0.334	1.000	0.182
sqft_lot15	-0.140	0.002	0.082	0.029	0.087	0.183	0.718	-0.012	0.031	0.073	-0.004	0.118	0.193	0.017	0.070	0.008	-0.147	-0.087	0.254	0.182	1.000

Heatmap
Table

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
id	1.000	0.006	0.002	0.006	0.014	0.000	-0.117	0.018	-0.004	0.012	-0.024	0.018	0.002	0.001	0.026	-0.018	-0.005	-0.005	0.006	-0.001	-0.115
date	0.006	1.000	-0.014	-0.018	-0.035	-0.036	-0.013	-0.025	0.002	-0.000	-0.046	-0.043	-0.027	-0.014	-0.003	-0.025	0.002	-0.030	-0.006	-0.029	-0.013
price	0.002	-0.014	1.000	0.345	0.495	0.644	0.076	0.320	0.115	0.293	0.017	0.656	0.540	0.252	0.098	0.102	-0.006	0.456	0.061	0.572	0.064
bedrooms	0.006	-0.018	0.345	1.000	0.522	0.648	0.217	0.227	-0.008	0.081	0.012	0.382	0.540	0.230	0.179	0.017	-0.168	-0.023	0.191	0.445	0.202
bathrooms	0.014	-0.035	0.495	0.522	1.000	0.745	0.069	0.546	0.050	0.155	-0.166	0.657	0.690	0.191	0.566	0.043	-0.203	0.007	0.260	0.570	0.063
sqft_living	0.000	-0.036	0.644	0.648	0.745	1.000	0.306	0.400	0.070	0.232	-0.065	0.716	0.844	0.327	0.351	0.052	-0.206	0.029	0.284	0.747	0.285
sqft_lot	-0.117	-0.013	0.076	0.217	0.069	0.306	1.000	-0.235	0.086	0.117	0.115	0.153	0.273	0.037	-0.039	0.008	-0.320	-0.121	0.371	0.361	0.923
floors	0.018	-0.025	0.320	0.227	0.546	0.400	-0.235	1.000	0.024	0.019	-0.291	0.501	0.598	-0.273	0.552	0.012	-0.060	0.024	0.148	0.305	-0.232
waterfront	-0.004	0.002	0.115	-0.008	0.050	0.070	0.086	0.024	1.000	0.286	0.017	0.062	0.054	0.052	-0.029	0.092	0.030	-0.019	-0.038	0.075	0.093
view	0.012	-0.000	0.293	0.081	0.155	0.232	0.117	0.019	0.286	1.000	0.046	0.216	0.143	0.236	-0.068	0.096	0.080	-0.001	-0.104	0.255	0.117
condition	-0.024	-0.046	0.017	0.012	-0.166	-0.065	0.115	-0.291	0.017	0.046	1.000	-0.171	-0.161	0.162	-0.398	-0.067	-0.021	-0.023	-0.087	-0.089	0.118
grade	0.018	-0.043	0.656	0.382	0.657	0.716	0.153	0.501	0.062	0.216	-0.171	1.000	0.712	0.092	0.499	0.016	-0.179	0.102	0.221	0.662	0.157
sqft_above	0.002	-0.027	0.540	0.540	0.690	0.844	0.273	0.598	0.054	0.143	-0.161	0.712	1.000	-0.167	0.471	0.030	-0.277	-0.027	0.385	0.697	0.255
sqft_basement	0.001	-0.014	0.252	0.230	0.191	0.327	0.037	-0.273	0.052	0.236	0.162	0.092	-0.167	1.000	-0.180	0.063	0.115	0.114	-0.201	0.129	0.031
yr_built	0.026	-0.003	0.098	0.179	0.566	0.351	-0.039	0.552	-0.029	-0.068	-0.398	0.499	0.471	-0.180	1.000	-0.215	-0.315	-0.126	0.411	0.334	-0.018
yr_renovated	-0.018	-0.025	0.102	0.017	0.043	0.052	0.008	0.012	0.092	0.096	-0.067	0.016	0.030	0.063	-0.215	1.000	0.062	0.025	-0.076	-0.006	0.009
zipcode	-0.005	0.002	-0.006	-0.168	-0.203	-0.206	-0.320	-0.060	0.030	0.080	-0.021	-0.179	-0.277	0.115	-0.315	0.062	1.000	0.249	-0.578	-0.287	-0.327
lat	-0.005	-0.030	0.456	-0.023	0.007	0.029	-0.121	0.024	-0.019	-0.001	-0.023	0.102	-0.027	0.114	-0.126	0.025	0.249	1.000	-0.144	0.026	-0.116
long	0.006	-0.006	0.061	0.191	0.260	0.284	0.371	0.148	-0.038	-0.104	-0.087	0.221	0.385	-0.201	0.411	-0.076	-0.578	-0.144	1.000	0.380	0.373
sqft_living15	-0.001	-0.029	0.572	0.445	0.570	0.747	0.361	0.305	0.075	0.255	-0.089	0.662	0.697	0.129	0.334	-0.006	-0.287	0.026	0.380	1.000	0.367
sqft_lot15	-0.115	-0.013	0.064	0.202	0.063	0.285	0.923	-0.232	0.093	0.117	0.118	0.157	0.255	0.031	-0.018	0.009	-0.327	-0.116	0.373	0.367	1.000

Heatmap
Table

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
id	1.000	0.004	0.002	0.005	0.010	0.000	-0.079	0.014	-0.003	0.010	-0.019	0.014	0.002	0.001	0.018	-0.014	-0.004	-0.003	0.004	-0.001	-0.078
date	0.004	1.000	-0.009	-0.014	-0.025	-0.024	-0.009	-0.019	0.001	-0.000	-0.037	-0.032	-0.018	-0.010	-0.002	-0.020	0.001	-0.020	-0.004	-0.019	-0.008
price	0.002	-0.009	1.000	0.266	0.368	0.463	0.048	0.250	0.094	0.237	0.013	0.526	0.377	0.191	0.067	0.082	-0.008	0.293	0.038	0.404	0.039
bedrooms	0.005	-0.014	0.266	1.000	0.440	0.522	0.165	0.201	-0.007	0.074	0.011	0.332	0.430	0.196	0.141	0.015	-0.128	-0.017	0.144	0.347	0.154
bathrooms	0.010	-0.025	0.368	0.440	1.000	0.588	0.050	0.451	0.043	0.132	-0.140	0.556	0.530	0.153	0.428	0.037	-0.143	0.005	0.187	0.430	0.046
sqft_living	0.000	-0.024	0.463	0.522	0.588	1.000	0.208	0.315	0.058	0.187	-0.052	0.586	0.697	0.265	0.243	0.042	-0.138	0.019	0.191	0.571	0.193
sqft_lot	-0.079	-0.009	0.048	0.165	0.050	0.208	1.000	-0.187	0.070	0.094	0.090	0.112	0.186	0.028	-0.006	0.007	-0.206	-0.080	0.258	0.245	0.793
floors	0.014	-0.019	0.250	0.201	0.451	0.315	-0.187	1.000	0.023	0.018	-0.268	0.435	0.475	-0.236	0.418	0.011	-0.049	0.019	0.115	0.239	-0.184
waterfront	-0.003	0.001	0.094	-0.007	0.043	0.058	0.070	0.023	1.000	0.281	0.016	0.057	0.045	0.047	-0.024	0.091	0.025	-0.016	-0.031	0.061	0.076
view	0.010	-0.000	0.237	0.074	0.132	0.187	0.094	0.018	0.281	1.000	0.043	0.195	0.115	0.212	-0.055	0.094	0.065	-0.001	-0.084	0.206	0.094
condition	-0.019	-0.037	0.013	0.011	-0.140	-0.052	0.090	-0.268	0.016	0.043	1.000	-0.152	-0.128	0.143	-0.322	-0.064	-0.018	-0.018	-0.069	-0.071	0.093
grade	0.014	-0.032	0.526	0.332	0.556	0.586	0.112	0.435	0.057	0.195	-0.152	1.000	0.581	0.078	0.385	0.014	-0.135	0.072	0.165	0.536	0.115
sqft_above	0.002	-0.018	0.377	0.430	0.530	0.697	0.186	0.475	0.045	0.115	-0.128	0.581	1.000	-0.119	0.332	0.024	-0.182	-0.018	0.261	0.516	0.174
sqft_basement	0.001	-0.010	0.191	0.196	0.153	0.265	0.028	-0.236	0.047	0.212	0.143	0.078	-0.119	1.000	-0.131	0.057	0.088	0.084	-0.147	0.102	0.024
yr_built	0.018	-0.002	0.067	0.141	0.428	0.243	-0.006	0.418	-0.024	-0.055	-0.322	0.385	0.332	-0.131	1.000	-0.175	-0.185	-0.084	0.297	0.231	0.008
yr_renovated	-0.014	-0.020	0.082	0.015	0.037	0.042	0.007	0.011	0.091	0.094	-0.064	0.014	0.024	0.057	-0.175	1.000	0.051	0.020	-0.061	-0.005	0.007
zipcode	-0.004	0.001	-0.008	-0.128	-0.143	-0.138	-0.206	-0.049	0.025	0.065	-0.018	-0.135	-0.182	0.088	-0.185	0.051	1.000	0.176	-0.364	-0.191	-0.209
lat	-0.003	-0.020	0.293	-0.017	0.005	0.019	-0.080	0.019	-0.016	-0.001	-0.018	0.072	-0.018	0.084	-0.084	0.020	0.176	1.000	-0.095	0.016	-0.076
long	0.004	-0.004	0.038	0.144	0.187	0.191	0.258	0.115	-0.031	-0.084	-0.069	0.165	0.261	-0.147	0.297	-0.061	-0.364	-0.095	1.000	0.258	0.261
sqft_living15	-0.001	-0.019	0.404	0.347	0.430	0.571	0.245	0.239	0.061	0.206	-0.071	0.536	0.516	0.102	0.231	-0.005	-0.191	0.016	0.258	1.000	0.250
sqft_lot15	-0.078	-0.008	0.039	0.154	0.046	0.193	0.793	-0.184	0.076	0.094	0.093	0.115	0.174	0.024	0.008	0.007	-0.209	-0.076	0.261	0.250	1.000

Heatmap
Table

	id	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
id	1.000	0.073	0.042	0.079	0.079	0.084	0.080	0.008	0.067	0.072	0.110	0.087	0.062	0.161	0.037	0.350	0.266	0.325	0.118	0.095
price	0.073	1.000	0.296	0.742	0.898	0.039	0.206	0.419	0.461	0.055	0.656	0.791	0.793	0.114	0.167	0.176	0.341	0.147	0.543	0.000
bedrooms	0.042	0.296	1.000	0.514	0.578	0.000	0.206	0.000	0.100	0.062	0.373	0.505	0.359	0.215	0.016	0.202	0.110	0.208	0.440	0.000
bathrooms	0.079	0.742	0.514	1.000	0.872	0.078	0.468	0.133	0.267	0.302	0.717	0.846	0.731	0.591	0.078	0.335	0.243	0.341	0.614	0.093
sqft_living	0.079	0.898	0.578	0.872	1.000	0.098	0.361	0.183	0.341	0.142	0.751	0.912	0.916	0.368	0.093	0.313	0.209	0.300	0.744	0.115
sqft_lot	0.084	0.039	0.000	0.078	0.098	1.000	0.036	0.014	0.070	0.071	0.092	0.131	0.057	0.076	0.000	0.087	0.134	0.170	0.059	0.628
floors	0.080	0.206	0.206	0.468	0.361	0.036	1.000	0.031	0.035	0.261	0.371	0.491	0.227	0.620	0.083	0.336	0.248	0.302	0.340	0.035
waterfront	0.008	0.419	0.000	0.133	0.183	0.014	0.031	1.000	0.490	0.014	0.153	0.107	0.176	0.044	0.144	0.104	0.045	0.126	0.117	0.000
view	0.067	0.461	0.100	0.267	0.341	0.070	0.035	0.490	1.000	0.065	0.316	0.211	0.363	0.103	0.089	0.178	0.162	0.201	0.337	0.057
condition	0.072	0.055	0.062	0.302	0.142	0.071	0.261	0.014	0.065	1.000	0.345	0.251	0.223	0.532	0.055	0.175	0.136	0.191	0.149	0.022
grade	0.110	0.656	0.373	0.717	0.751	0.092	0.371	0.153	0.316	0.345	1.000	0.760	0.359	0.497	0.018	0.322	0.330	0.294	0.728	0.079
sqft_above	0.087	0.791	0.505	0.846	0.912	0.131	0.491	0.107	0.211	0.251	0.760	1.000	0.654	0.498	0.041	0.405	0.201	0.390	0.747	0.153
sqft_basement	0.062	0.793	0.359	0.731	0.916	0.057	0.227	0.176	0.363	0.223	0.359	0.654	1.000	0.287	0.102	0.190	0.157	0.188	0.383	0.090
yr_built	0.161	0.114	0.215	0.591	0.368	0.076	0.620	0.044	0.103	0.532	0.497	0.498	0.287	1.000	0.303	0.620	0.445	0.542	0.404	0.065
yr_renovated	0.037	0.167	0.016	0.078	0.093	0.000	0.083	0.144	0.089	0.055	0.018	0.041	0.102	0.303	1.000	0.112	0.077	0.108	0.000	0.000
zipcode	0.350	0.176	0.202	0.335	0.313	0.087	0.336	0.104	0.178	0.175	0.322	0.405	0.190	0.620	0.112	1.000	0.792	0.786	0.442	0.113
lat	0.266	0.341	0.110	0.243	0.209	0.134	0.248	0.045	0.162	0.136	0.330	0.201	0.157	0.445	0.077	0.792	1.000	0.490	0.284	0.142
long	0.325	0.147	0.208	0.341	0.300	0.170	0.302	0.126	0.201	0.191	0.294	0.390	0.188	0.542	0.108	0.786	0.490	1.000	0.432	0.194
sqft_living15	0.118	0.543	0.440	0.614	0.744	0.059	0.340	0.117	0.337	0.149	0.728	0.747	0.383	0.404	0.000	0.442	0.284	0.432	1.000	0.086
sqft_lot15	0.095	0.000	0.000	0.093	0.115	0.628	0.035	0.000	0.057	0.022	0.079	0.153	0.090	0.065	0.000	0.113	0.142	0.194	0.086	1.000

Heatmap
Table

	condition	view	waterfront
condition	1.000	0.024	0.017
view	0.024	1.000	0.595
waterfront	0.017	0.595	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
0	7129300520	2014-10-13	221900.0	3	1.00	1180	5650	1.0	3	7	1180	0	1955	0	98178	47.5112	-122.257	1340	5650
1	6414100192	2014-12-09	538000.0	3	2.25	2570	7242	2.0	3	7	2170	400	1951	1991	98125	47.7210	-122.319	1690	7639
2	5631500400	2015-02-25	180000.0	2	1.00	770	10000	1.0	3	6	770	0	1933	0	98028	47.7379	-122.233	2720	8062
3	2487200875	2014-12-09	604000.0	4	3.00	1960	5000	1.0	5	7	1050	910	1965	0	98136	47.5208	-122.393	1360	5000
4	1954400510	2015-02-18	510000.0	3	2.00	1680	8080	1.0	3	8	1680	0	1987	0	98074	47.6168	-122.045	1800	7503
5	7237550310	2014-05-12	1225000.0	4	4.50	5420	101930	1.0	3	11	3890	1530	2001	0	98053	47.6561	-122.005	4760	101930
6	1321400060	2014-06-27	257500.0	3	2.25	1715	6819	2.0	3	7	1715	0	1995	0	98003	47.3097	-122.327	2238	6819
7	2008000270	2015-01-15	291850.0	3	1.50	1060	9711	1.0	3	7	1060	0	1963	0	98198	47.4095	-122.315	1650	9711
8	2414600126	2015-04-15	229500.0	3	1.00	1780	7470	1.0	3	7	1050	730	1960	0	98146	47.5123	-122.337	1780	8113
9	3793500160	2015-03-12	323000.0	3	2.50	1890	6560	2.0	3	7	1890	0	2003	0	98038	47.3684	-122.031	2390	7570

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15
21603	7852140040	2014-08-25	507250.0	3	2.50	2270	5536	2.0	3	8	2270	0	2003	98065	47.5389	-121.881	2270	5731
21604	9834201367	2015-01-26	429000.0	3	2.00	1490	1126	3.0	3	8	1490	0	2014	98144	47.5699	-122.288	1400	1230
21605	3448900210	2014-10-14	610685.0	4	2.50	2520	6023	2.0	3	9	2520	0	2014	98056	47.5137	-122.167	2520	6023
21606	7936000429	2015-03-26	1007500.0	4	3.50	3510	7200	2.0	3	9	2600	910	2009	98136	47.5537	-122.398	2050	6200
21607	2997800021	2015-02-19	475000.0	3	2.50	1310	1294	2.0	3	8	1180	130	2008	98116	47.5773	-122.409	1330	1265
21608	263000018	2014-05-21	360000.0	3	2.50	1530	1131	3.0	3	8	1530	0	2009	98103	47.6993	-122.346	1530	1509
21609	6600060120	2015-02-23	400000.0	4	2.50	2310	5813	2.0	3	8	2310	0	2014	98146	47.5107	-122.362	1830	7200
21610	1523300141	2014-06-23	402101.0	2	0.75	1020	1350	2.0	3	7	1020	0	2009	98144	47.5944	-122.299	1020	2007
21611	291310100	2015-01-16	400000.0	3	2.50	1600	2388	2.0	3	8	1600	0	2004	98027	47.5345	-122.069	1410	1287
21612	1523300157	2014-10-15	325000.0	2	0.75	1020	1076	2.0	3	7	1020	0	2008	98144	47.5941	-122.299	1020	1357

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample